Re: [appfuse-user] oracle database profile:org.hibernate.exception.JDBCConnectionException

Mon, 18 Aug 2008 12:42:24 -0700

It looks like it's still trying to connect to MySQL - don't know why though.
On Aug 18, 2008, at 12:38 PM, WalterScott <[EMAIL PROTECTED]> wrote: 



An error occurs when I start mvn appfuse:gen-model command.

With default mysql profile this works fine, but when I choose the  
oracle

profile by default, how I described below:
       <profile>
           <id>oracle</id>
           <activation>
               <activeByDefault>true</activeByDefault>
           </activation>
           <properties>


<dbunit. 
dataTypeFactoryName>org.dbunit.ext.oracle.OracleDataTypeFactory</ 
dbunit.dataTypeFactoryName>

               <dbunit.schema>SYSTEM</dbunit.schema> <!-- Make sure to
capitalize the schema name -->


<hibernate.dialect>org.hibernate.dialect.Oracle10Dialect</ 
hibernate.dialect>

               <jdbc.groupId>com.oracle</jdbc.groupId>
               <jdbc.artifactId>ojdbc14</jdbc.artifactId>
               <jdbc.version>10.1.0.2.0</jdbc.version>

<jdbc.driverClassName>oracle.jdbc.OracleDriver</jdbc.driverClassName>

<jdbc.url><![CDATA[jdbc:oracle:thin:@127.0.0.1:1521:ORCL]]></jdbc.url>
               <jdbc.username>system</jdbc.username>
               <jdbc.password>myrealpassword</jdbc.password>
           </properties>
       </profile>

I get error message:
[INFO] Scanning for projects...
[INFO] Searching repository for plugin with prefix: 'appfuse'.
[INFO]

--- 
---------------------------------------------------------------------

[INFO] Building AppFuse Spring MVC Application
[INFO]    task-segment: [appfuse:gen-model]
[INFO]

--- 
---------------------------------------------------------------------

[INFO] Preparing appfuse:gen-model
[INFO] [warpath:add-classes {execution: default}]
[INFO] [aspectj:compile {execution: default}]
[INFO] [native2ascii:native2ascii {execution: native2ascii-utf8}]
[INFO] [native2ascii:native2ascii {execution: native2ascii-8859_1}]
[INFO] [resources:resources]
[INFO] Using default encoding to copy filtered resources.

[WARNING] POM for 'org.hibernate:jtidy:pom:r8-20060801:runtime' is  
invalid.
It will be ignored for artifact resolution. Reason: Parse error  
reading POM.

Reason: TEXT must be immediately followed by END_TAG and not START_TAG

(position: START_TAG seen ...<licenses>\n\t\t\t<license>... @12:13)   
for

project org.hibernate:jtidy at

E:\docume~1\Evgeny\.m2\repository\org\hibernate\jtidy 
\r8-20060801\jtidy-r8-20060801.pom

[INFO] [appfuse:gen-model]
[INFO] Configuration XML file loaded:
file:/E:/dev/apps/advert/src/main/resources/hibernate.cfg.xml
[INFO] Configuration Properties file loaded:
E:\dev\apps\advert\target\classes\jdbc.properties
[INFO]

--- 
---------------------------------------------------------------------

[ERROR] FATAL ERROR
[INFO]

--- 
---------------------------------------------------------------------

[INFO] Getting database metadata
Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.ConnectException
MESSAGE: Connection refused: connect

STACKTRACE:

java.net.ConnectException: Connection refused: connect
   at java.net.PlainSocketImpl.socketConnect(Native Method)
   at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)

   at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java: 
195)

   at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
   at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
   at java.net.Socket.connect(Socket.java:519)
   at java.net.Socket.connect(Socket.java:469)
   at java.net.Socket.<init>(Socket.java:366)
   at java.net.Socket.<init>(Socket.java:209)
   at

com. 
mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java: 
173)

   at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:267)
   at com.mysql.jdbc.Connection.createNewIO(Connection.java:2739)
   at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
   at

com. 
mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

   at java.sql.DriverManager.getConnection(DriverManager.java:582)
   at java.sql.DriverManager.getConnection(DriverManager.java:154)
   at

org. 
hibernate. 
connection. 
DriverManagerConnectionProvider. 
getConnection(DriverManagerConnectionProvider.java:110)

   at

org. 
hibernate. 
cfg. 
reveng. 
dialect. 
AbstractMetaDataDialect.getConnection(AbstractMetaDataDialect.java: 
122)

   at

org. 
hibernate. 
cfg. 
reveng. 
dialect. 
AbstractMetaDataDialect.getMetaData(AbstractMetaDataDialect.java:61)

   at

org. 
hibernate. 
cfg. 
reveng. 
dialect. 
AbstractMetaDataDialect.caseForSearch(AbstractMetaDataDialect.java: 
163)

   at

org. 
hibernate. 
cfg. 
reveng. 
dialect.JDBCMetaDataDialect.getTables(JDBCMetaDataDialect.java:22)
   at  
org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:476)

   at

org. 
hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:74)

   at

org. 
hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java: 
860)
   at  
org.hibernate.cfg.JDBCBinder.readDatabaseSchema(JDBCBinder.java:115)
   at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java: 
88)

   at

org. 
hibernate. 
cfg. 
JDBCMetaDataConfiguration. 
readFromJDBC(JDBCMetaDataConfiguration.java:42)

   at

org. 
codehaus. 
mojo. 
hibernate3. 
configuration. 
JDBCComponentConfiguration. 
doConfiguration(JDBCComponentConfiguration.java:67)

   at

org. 
codehaus. 
mojo. 
hibernate3. 
configuration. 
AbstractComponentConfiguration. 
getConfiguration(AbstractComponentConfiguration.java:40)

   at

org. 
appfuse. 
mojo. 
HibernateExporterMojo.configureExporter(HibernateExporterMojo.java: 
180)

   at

org. 
appfuse. 
mojo. 
exporter. 
ModelGeneratorMojo.configureExporter(ModelGeneratorMojo.java:221)

   at

org. 
appfuse. 
mojo.HibernateExporterMojo.doExecute(HibernateExporterMojo.java:228)

   at

org. 
appfuse. 
mojo.exporter.ModelGeneratorMojo.execute(ModelGeneratorMojo.java:183)

   at

org. 
apache. 
maven. 
plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:451)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java: 
558)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor. 
executeStandaloneGoal(DefaultLifecycleExecutor.java:512)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java: 
482)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor. 
executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:330)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor. 
executeTaskSegments(DefaultLifecycleExecutor.java:291)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:142)

   at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:336)
   at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:129)
   at org.apache.maven.cli.MavenCli.main(MavenCli.java:287)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at

sun. 
reflect. 
NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

   at

sun. 
reflect. 
DelegatingMethodAccessorImpl. 
invoke(DelegatingMethodAccessorImpl.java:25)

   at java.lang.reflect.Method.invoke(Method.java:597)

   at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java: 
315)

   at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)

   at  
org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)

   at org.codehaus.classworlds.Launcher.main(Launcher.java:375)


** END NESTED EXCEPTION **



Last packet sent to the server was 0 ms ago.
[INFO]

--- 
---------------------------------------------------------------------

[INFO] Trace

org.hibernate.exception.JDBCConnectionException: Getting database  
metadata

   at

org. 
hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java: 
74)

   at

org. 
hibernate. 
cfg. 
reveng. 
dialect. 
AbstractMetaDataDialect.getMetaData(AbstractMetaDataDialect.java:64)

   at

org. 
hibernate. 
cfg. 
reveng. 
dialect. 
AbstractMetaDataDialect.caseForSearch(AbstractMetaDataDialect.java: 
163)

   at

org. 
hibernate. 
cfg. 
reveng. 
dialect.JDBCMetaDataDialect.getTables(JDBCMetaDataDialect.java:22)
   at  
org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:476)

   at

org. 
hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:74)

   at

org. 
hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java: 
860)
   at  
org.hibernate.cfg.JDBCBinder.readDatabaseSchema(JDBCBinder.java:115)
   at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java: 
88)

   at

org. 
hibernate. 
cfg. 
JDBCMetaDataConfiguration. 
readFromJDBC(JDBCMetaDataConfiguration.java:42)

   at

org. 
codehaus. 
mojo. 
hibernate3. 
configuration. 
JDBCComponentConfiguration. 
doConfiguration(JDBCComponentConfiguration.java:67)

   at

org. 
codehaus. 
mojo. 
hibernate3. 
configuration. 
AbstractComponentConfiguration. 
getConfiguration(AbstractComponentConfiguration.java:40)

   at

org. 
appfuse. 
mojo. 
HibernateExporterMojo.configureExporter(HibernateExporterMojo.java: 
180)

   at

org. 
appfuse. 
mojo. 
exporter. 
ModelGeneratorMojo.configureExporter(ModelGeneratorMojo.java:221)

   at

org. 
appfuse. 
mojo.HibernateExporterMojo.doExecute(HibernateExporterMojo.java:228)

   at

org. 
appfuse. 
mojo.exporter.ModelGeneratorMojo.execute(ModelGeneratorMojo.java:183)

   at

org. 
apache. 
maven. 
plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:451)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java: 
558)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor. 
executeStandaloneGoal(DefaultLifecycleExecutor.java:512)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java: 
482)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor. 
executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:330)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor. 
executeTaskSegments(DefaultLifecycleExecutor.java:291)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:142)

   at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:336)
   at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:129)
   at org.apache.maven.cli.MavenCli.main(MavenCli.java:287)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at

sun. 
reflect. 
NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

   at

sun. 
reflect. 
DelegatingMethodAccessorImpl. 
invoke(DelegatingMethodAccessorImpl.java:25)

   at java.lang.reflect.Method.invoke(Method.java:597)

   at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java: 
315)

   at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)

   at  
org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)

   at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link
failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.ConnectException
MESSAGE: Connection refused: connect

STACKTRACE:

java.net.ConnectException: Connection refused: connect
   at java.net.PlainSocketImpl.socketConnect(Native Method)
   at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)

   at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java: 
195)

   at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
   at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
   at java.net.Socket.connect(Socket.java:519)
   at java.net.Socket.connect(Socket.java:469)
   at java.net.Socket.<init>(Socket.java:366)
   at java.net.Socket.<init>(Socket.java:209)
   at

com. 
mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java: 
173)

   at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:267)
   at com.mysql.jdbc.Connection.createNewIO(Connection.java:2739)
   at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
   at

com. 
mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

   at java.sql.DriverManager.getConnection(DriverManager.java:582)
   at java.sql.DriverManager.getConnection(DriverManager.java:154)
   at

org. 
hibernate. 
connection. 
DriverManagerConnectionProvider. 
getConnection(DriverManagerConnectionProvider.java:110)

   at

org. 
hibernate. 
cfg. 
reveng. 
dialect. 
AbstractMetaDataDialect.getConnection(AbstractMetaDataDialect.java: 
122)

   at

org. 
hibernate. 
cfg. 
reveng. 
dialect. 
AbstractMetaDataDialect.getMetaData(AbstractMetaDataDialect.java:61)

   at

org. 
hibernate. 
cfg. 
reveng. 
dialect. 
AbstractMetaDataDialect.caseForSearch(AbstractMetaDataDialect.java: 
163)

   at

org. 
hibernate. 
cfg. 
reveng. 
dialect.JDBCMetaDataDialect.getTables(JDBCMetaDataDialect.java:22)
   at  
org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:476)

   at

org. 
hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:74)

   at

org. 
hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java: 
860)
   at  
org.hibernate.cfg.JDBCBinder.readDatabaseSchema(JDBCBinder.java:115)
   at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java: 
88)

   at

org. 
hibernate. 
cfg. 
JDBCMetaDataConfiguration. 
readFromJDBC(JDBCMetaDataConfiguration.java:42)

   at

org. 
codehaus. 
mojo. 
hibernate3. 
configuration. 
JDBCComponentConfiguration. 
doConfiguration(JDBCComponentConfiguration.java:67)

   at

org. 
codehaus. 
mojo. 
hibernate3. 
configuration. 
AbstractComponentConfiguration. 
getConfiguration(AbstractComponentConfiguration.java:40)

   at

org. 
appfuse. 
mojo. 
HibernateExporterMojo.configureExporter(HibernateExporterMojo.java: 
180)

   at

org. 
appfuse. 
mojo. 
exporter. 
ModelGeneratorMojo.configureExporter(ModelGeneratorMojo.java:221)

   at

org. 
appfuse. 
mojo.HibernateExporterMojo.doExecute(HibernateExporterMojo.java:228)

   at

org. 
appfuse. 
mojo.exporter.ModelGeneratorMojo.execute(ModelGeneratorMojo.java:183)

   at

org. 
apache. 
maven. 
plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:451)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java: 
558)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor. 
executeStandaloneGoal(DefaultLifecycleExecutor.java:512)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java: 
482)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor. 
executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:330)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor. 
executeTaskSegments(DefaultLifecycleExecutor.java:291)

   at

org. 
apache. 
maven. 
lifecycle. 
DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:142)

   at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:336)
   at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:129)
   at org.apache.maven.cli.MavenCli.main(MavenCli.java:287)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at

sun. 
reflect. 
NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

   at

sun. 
reflect. 
DelegatingMethodAccessorImpl. 
invoke(DelegatingMethodAccessorImpl.java:25)

   at java.lang.reflect.Method.invoke(Method.java:597)

   at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java: 
315)

   at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)

   at  
org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)

   at org.codehaus.classworlds.Launcher.main(Launcher.java:375)


** END NESTED EXCEPTION **



Last packet sent to the server was 0 ms ago.
   at com.mysql.jdbc.Connection.createNewIO(Connection.java:2814)
   at com.mysql.jdbc.Connection.<init>(Connection.java:1553)
   at

com. 
mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

   at java.sql.DriverManager.getConnection(DriverManager.java:582)
   at java.sql.DriverManager.getConnection(DriverManager.java:154)
   at

org. 
hibernate. 
connection. 
DriverManagerConnectionProvider. 
getConnection(DriverManagerConnectionProvider.java:110)

   at

org. 
hibernate. 
cfg. 
reveng. 
dialect. 
AbstractMetaDataDialect.getConnection(AbstractMetaDataDialect.java: 
122)

   at

org. 
hibernate. 
cfg. 
reveng. 
dialect. 
AbstractMetaDataDialect.getMetaData(AbstractMetaDataDialect.java:61)

   ... 32 more
[INFO]

--- 
---------------------------------------------------------------------

[INFO] Total time: 9 seconds
[INFO] Finished at: Mon Aug 18 22:11:49 MSD 2008
[INFO] Final Memory: 17M/34M
[INFO]

--- 
---------------------------------------------------------------------

--
View this message in context: 
http://www.nabble.com/oracle-database-profile%3Aorg.hibernate.exception.JDBCConnectionException-tp19035653s2369p19035653.html
Sent from the AppFuse - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]























					Reply via email to