Comments (6)
ORA-01441: cannot decrease column length because some value is too big
Above error will produce when you are trying to modify the column to one value, and that column contains data, whose length is more than setting value, then it will throw error.
So, the only solution is to find the row-column values whose length is more that setting value and modify the data to a small value.
from jooby.
Is a the driver the issue? The HikariModule set up pool class name to oracle.jdbc.pool.OracleDataSource
Don't seem to be a Jooby issue.
from jooby.
I tried to make a manual connection, and it has no problems.
public class HibernateUtil {
private static SessionFactory sessionFactory;
public static SessionFactory getSessionFactory() {
if (sessionFactory == null) {
StandardServiceRegistry standardRegistry = new StandardServiceRegistryBuilder()
.applySettings(getConfigurationProperties())
.build();
try {
Metadata metadata = new MetadataSources(standardRegistry)
.addAnnotatedClass(Test.class)
.buildMetadata();
sessionFactory = metadata.getSessionFactoryBuilder().build();
} catch (Exception e) {
System.err.println("Error create SessionFactory: " + e);
if (standardRegistry != null) {
StandardServiceRegistryBuilder.destroy(standardRegistry);
}
}
}
return sessionFactory;
}
private static Properties getConfigurationProperties() {
Properties properties = new Properties();
properties.put(Environment.DRIVER, "oracle.jdbc.driver.OracleDriver");
properties.put(Environment.URL, "jdbc:oracle:thin:@domain.com:1521:PHX");
properties.put(Environment.USER, "USER");
properties.put(Environment.PASS, "PASSWORD");
properties.put(Environment.DIALECT, "org.hibernate.dialect.OracleDialect");
properties.put(Environment.SHOW_SQL, "true");
properties.put(Environment.FORMAT_SQL, "true");
properties.put(Environment.HBM2DDL_AUTO, "validate");
return properties;
}
public static void shutdown() {
if (sessionFactory != null) {
sessionFactory.close();
}
}
}
But when I use "HibernateModule" and "HikariModule" for connection, I get the problem described above. And it appears at the server startup, I do not even open any page.
Unfortunately, I canβt find a solution to the problem on my own, so I came to ask you for help.
and my gradle
buildscript {
ext {
joobyVersion = System.getProperty("joobyVersion")
}
}
plugins {
id "application"
id "io.jooby.run" version "${joobyVersion}"
id "io.spring.dependency-management" version "1.1.0"
id "com.google.osdetector" version "1.7.3"
id "com.github.johnrengelman.shadow" version "8.1.1"
}
group "com.test"
version "1.0.0"
mainClassName = "com.test.App"
sourceCompatibility = 21
repositories {
mavenLocal()
mavenCentral()
}
dependencyManagement {
imports {
mavenBom "io.jooby:jooby-bom:$joobyVersion"
}
}
dependencies {
implementation "io.jooby:jooby-netty"
implementation "io.jooby:jooby-logback"
implementation "io.jooby:jooby-guice"
annotationProcessor "io.jooby:jooby-apt"
implementation 'org.reflections:reflections:0.10.2'
implementation 'io.jooby:jooby-hikari:3.1.2'
implementation 'io.jooby:jooby-hibernate:3.1.2'
implementation 'com.oracle.database.jdbc:ojdbc10:19.23.0.0'
testImplementation "org.junit.jupiter:junit-jupiter-api:5.10.2"
testImplementation "org.junit.jupiter:junit-jupiter-engine:5.10.2"
testImplementation "io.jooby:jooby-test"
testImplementation "com.squareup.okhttp3:okhttp:4.12.0"
}
test {
useJUnitPlatform()
}
/** Java debug information: */
tasks.withType(JavaCompile) {
options.compilerArgs += [
'-parameters',
]
options.debug = true
}
shadowJar {
mergeServiceFiles()
}
joobyRun {
mainClass = mainClassName
restartExtensions = ["conf", "properties", "class"]
compileExtensions = ["java"]
port = 8080
}
from jooby.
Odd. Is there way to bootstrap an oracle db with Docker? Never used Oracle :S
from jooby.
Odd. Is there way to bootstrap an oracle db with Docker? Never used Oracle :S
Hello, unfortunately there is no such possibility.
And you also have no ideas on how to solve my problem?
from jooby.
ORA-01441: cannot decrease column length because some value is too big
Seems to be a schema/datatype issue, but I can't reproduce it to be 100% sure
from jooby.
Related Issues (20)
- [netty] Broken swagger-ui HOT 1
- buffer: write(String str, int off, int len) doesn't work
- Conscrypt should not be included by default HOT 2
- File and image transfer problems in 3.1.x HOT 5
- How to set application environment when using joobyRun? HOT 2
- Jooby 2.16.3: Guice version has issues with Java 21 HOT 2
- How does Jooby handle gzip encoding for requests and responses? HOT 2
- OpenAPI generation issue in multimodule project HOT 3
- @ResultType: new annotation for source code generator
- jooby-apt: generate kotlin source code HOT 1
- OpenApi Circular reference generation HOT 2
- WebSocket onClose not called for Netty HOT 1
- netty: memory leak while reading HTTP body HOT 2
- Java strings not escaped properly in mvc source code generation. HOT 2
- DataBuffer interface needs reference to Spring Project and proper nullable annotations. HOT 1
- Maybe consider using package-info.java for default nonnull returns
- jooby-apt: MVC generated controllers require `jakarta-inject` should be documented because of code generation. HOT 2
- Support OpenAPI @io.swagger.v3.oas.annotations.Parameter on method parameters
- jooby-apt should not depend on commons-text which depends on commons-lang3 HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
π Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. πππ
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google β€οΈ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from jooby.