I almost score success with mvn -Poracle appfuse:gen-model command
[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
Downloading:
http://repo1.maven.org/maven2/com/oracle/ojdbc14/10.1.0.2.0/ojdbc14-10.1.0.2.0.pom
Downloading:
http://static.appfuse.org/repository/com/oracle/ojdbc14/10.1.0.2.0/ojdbc14-10.1.0.2.0.pom
[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] Error while reading column meta data for
SYS.SYSNTF5lujXmYSn2kltv3J8/8RQ==
ORA-01424: missing or illegal character following the escape character
[INFO]
------------------------------------------------------------------------
[INFO] Trace
org.hibernate.exception.DataException: Error while reading column meta data
for SYS.SYSNTF5lujXmYSn2kltv3J8/8RQ==
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
at
org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getColumns(JDBCMetaDataDialect.java:146)
at
org.hibernate.cfg.reveng.JDBCReader.processBasicColumns(JDBCReader.java:578)
at
org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:85)
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: java.sql.SQLException: ORA-01424: missing or illegal character
following the escape character
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at
oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543)
at
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:915)
at
oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929)
at
oracle.jdbc.driver.OracleDatabaseMetaData.getColumns(OracleDatabaseMetaData.java:276)
at
org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getColumns(JDBCMetaDataDialect.java:124)
... 30 more
[INFO]
------------------------------------------------------------------------
[INFO] Total time: 3 minutes 36 seconds
[INFO] Finished at: Wed Aug 20 21:50:36 MSD 2008
[INFO] Final Memory: 18M/37M
[INFO]
------------------------------------------------------------------------
The slash in table name is the reason?
dusty wrote:
>
> You must use -Poracle when you want it to connect to Oracle. So you
> need to do:
>
> mvn -Pprod appfuse:gen-model
>
>
>
> On Aug 19, 2008, at 1:11 PM, WalterScott wrote:
>
>>
>>
>> dusty wrote:
>>>
>>> When you run maven do you run: mvn -Poracle test?
>>>
>>> -D
>>>
>> When I run mvn -Poracle test, I get following:
>>
>> [INFO] Scanning for projects...
>> [INFO]
>> ------------------------------------------------------------------------
>> [INFO] Building AppFuse Spring MVC Application
>> [INFO] task-segment: [test]
>> [INFO]
>> ------------------------------------------------------------------------
>> Downloading:
>> http://repo1.maven.org/maven2/com/oracle/ojdbc14/10.1.0.2.0/ojdbc14-10.1.0.2.0.pom
>> Downloading:
>> http://static.appfuse.org/repository/com/oracle/ojdbc14/10.1.0.2.0/ojdbc14-10.1.0.2.0.pom
>> Downloading:
>> http://repo1.maven.org/maven2/com/oracle/ojdbc14/10.1.0.2.0/ojdbc14-10.1.0.2.0.jar
>> Downloading:
>> http://static.appfuse.org/repository/com/oracle/ojdbc14/10.1.0.2.0/ojdbc14-10.1.0.2.0.jar
>> [INFO]
>> ------------------------------------------------------------------------
>> [ERROR] BUILD ERROR
>> [INFO]
>> ------------------------------------------------------------------------
>> [INFO] Failed to resolve artifact.
>>
>> Missing:
>> ----------
>> 1) com.oracle:ojdbc14:jar:10.1.0.2.0
>>
>> Try downloading the file manually from the project website.
>>
>> Then, install it using the command:
>> mvn install:install-file -DgroupId=com.oracle -
>> DartifactId=ojdbc14
>> -Dversion=10.1.0.2.0 -Dpackaging=jar -Dfile=ojdbc14-10.1.0.2.0.jar
>>
>> Alternatively, if you host your own repository you can deploy the
>> file
>> there:
>> mvn deploy:deploy-file -DgroupId=com.oracle -DartifactId=ojdbc14
>> -Dversion=10.1.0.2.0 -Dpackaging=jar -Dfile=/path/to/file -Durl=[url]
>> -DrepositoryId=[id]
>>
>> Path to dependency:
>> 1) ru.advert:advert:war:1.0-SNAPSHOT
>> 2) com.oracle:ojdbc14:jar:10.1.0.2.0
>>
>> ----------
>> 1 required artifact is missing.
>>
>> for artifact:
>> ru.advert:advert:war:1.0-SNAPSHOT
>>
>> from the specified remote repositories:
>> appfuse (http://static.appfuse.org/repository),
>> central (http://repo1.maven.org/maven2)
>>
>>
>>
>>
>>
>>
>> I downloading ojdbc14-10.1.0.2.0.jar and install how describe above.
>> Now, when I run mvn -Poracle test, it creates tables in oracle such as
>> app_user, role, etc.
>> It means that connect to oracle successfully established.
>>
>> But when I run mvn appfuse:gen-model it's trying to connect to MySQL
>> again.
>>
>>
>>
>> dusty wrote:
>>>
>>> Do you have more than one profile active by default?
>>>
>> It`s my database and container profiles:
>> <!-- ================= Database Profiles ================= -->
>> <profile>
>> <id>derby</id>
>> <properties>
>>
>> <hibernate.dialect>org.hibernate.dialect.DerbyDialect</
>> hibernate.dialect>
>> <jdbc.groupId>org.apache.derby</jdbc.groupId>
>> <jdbc.artifactId>derbyclient</jdbc.artifactId>
>> <jdbc.version>10.2.2.0</jdbc.version>
>>
>> <jdbc.driverClassName>org.apache.derby.jdbc.ClientDriver</
>> jdbc.driverClassName>
>>
>> <jdbc.url><![CDATA[jdbc:derby://localhost/advert;create=true]]></
>> jdbc.url>
>> <jdbc.username>any</jdbc.username>
>> <jdbc.password>value</jdbc.password>
>> </properties>
>> </profile>
>> <profile>
>> <id>h2</id>
>> <properties>
>>
>> <
>> dbunit
>> .dataTypeFactoryName>org.dbunit.ext.hsqldb.HsqldbDataTypeFactory</
>> dbunit.dataTypeFactoryName>
>>
>> <hibernate.dialect>org.hibernate.dialect.H2Dialect</hibernate.dialect>
>> <jdbc.groupId>com.h2database</jdbc.groupId>
>> <jdbc.artifactId>h2</jdbc.artifactId>
>> <jdbc.version>1.0.20061217</jdbc.version>
>> <jdbc.driverClassName>org.h2.Driver</
>> jdbc.driverClassName>
>>
>> <jdbc.url><![CDATA[jdbc:h2:${java.io.tmpdir}/advert]]></jdbc.url>
>> <jdbc.username>sa</jdbc.username>
>> <jdbc.password></jdbc.password>
>> </properties>
>> </profile>
>> <profile>
>> <id>hsqldb</id>
>> <properties>
>>
>> <
>> dbunit
>> .dataTypeFactoryName>org.dbunit.ext.hsqldb.HsqldbDataTypeFactory</
>> dbunit.dataTypeFactoryName>
>>
>> <hibernate.dialect>org.hibernate.dialect.HSQLDialect</
>> hibernate.dialect>
>> <jdbc.groupId>hsqldb</jdbc.groupId>
>> <jdbc.artifactId>hsqldb</jdbc.artifactId>
>> <jdbc.version>1.8.0.7</jdbc.version>
>>
>> <jdbc.driverClassName>org.hsqldb.jdbcDriver</jdbc.driverClassName>
>>
>> <jdbc.url><![CDATA[jdbc:hsqldb:${java.io.tmpdir}/
>> advert;shutdown=true]]></jdbc.url>
>> <jdbc.username>sa</jdbc.username>
>> <jdbc.password></jdbc.password>
>> </properties>
>> </profile>
>> <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.Oracle9Dialect</
>> 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>shjuchgu</jdbc.password>
>> </properties>
>> </profile>
>> <profile>
>> <id>postgresql</id>
>> <properties>
>>
>> <hibernate.dialect>org.hibernate.dialect.PostgreSQLDialect</
>> hibernate.dialect>
>> <jdbc.groupId>postgresql</jdbc.groupId>
>> <jdbc.artifactId>postgresql</jdbc.artifactId>
>> <jdbc.version>8.1-407.jdbc3</jdbc.version>
>>
>> <jdbc.driverClassName>org.postgresql.Driver</jdbc.driverClassName>
>>
>> <jdbc.url><![CDATA[jdbc:postgresql://localhost/advert]]></jdbc.url>
>> <jdbc.username>postgres</jdbc.username>
>> <jdbc.password>postgres</jdbc.password>
>> </properties>
>> </profile>
>> <profile>
>> <!-- You need to enable TCP/IP Connections for SQL Server
>> 2005
>> after installing. -->
>> <!-- http://www.mattwoodward.com/blog/index.cfm?commentID=211
>> -->
>> <id>sqlserver</id>
>> <properties>
>>
>> <
>> dbunit
>> .dataTypeFactoryName>org.dbunit.ext.mssql.MsSqlDataTypeFactory</
>> dbunit.dataTypeFactoryName>
>>
>> <dbunit.operation.type>MSSQL_CLEAN_INSERT</dbunit.operation.type>
>>
>> <hibernate.dialect>org.hibernate.dialect.SQLServerDialect</
>> hibernate.dialect>
>> <jdbc.groupId>net.sourceforge.jtds</jdbc.groupId>
>> <jdbc.artifactId>jtds</jdbc.artifactId>
>> <jdbc.version>1.2</jdbc.version>
>>
>> <jdbc.driverClassName>net.sourceforge.jtds.jdbc.Driver</
>> jdbc.driverClassName>
>>
>> <jdbc.url><![CDATA[jdbc:jtds:sqlserver://localhost:3683/advert]]></
>> jdbc.url>
>> <jdbc.username>sa</jdbc.username>
>> <jdbc.password>appfuse</jdbc.password>
>> </properties>
>> </profile>
>>
>> <!-- ================= Container Profiles ================= -->
>> <profile>
>> <id>jboss</id>
>> <properties>
>> <cargo.container>jboss4x</cargo.container>
>>
>> <cargo.container.home>${env.JBOSS_HOME}</cargo.container.home>
>>
>> <cargo.container.url>http://easynews.dl.sourceforge.net/sourceforge/jboss/jboss-4.0.5.GA.zip
>>
>> </cargo.container.url>
>> </properties>
>> </profile>
>> </profiles>
>>
>> <properties>
>> <!-- Application settings -->
>> <copyright.year>2008</copyright.year>
>> <dao.framework>hibernate</dao.framework>
>> <web.framework>spring</web.framework>
>> <amp.genericCore>true</amp.genericCore>
>> <amp.fullSource>false</amp.fullSource>
>>
>> <!-- Framework dependency versions -->
>> <appfuse.version>2.0.2</appfuse.version>
>> <spring.version>2.5.4</spring.version>
>>
>> <!-- Testing dependency versions -->
>> <jmock.version>2.4.0</jmock.version>
>> <jsp.version>2.0</jsp.version>
>> <junit.version>4.4</junit.version>
>> <servlet.version>2.4</servlet.version>
>> <wiser.version>1.2</wiser.version>
>>
>> <!-- WebTest dependency versions -->
>> <webtest.version>R_1702</webtest.version>
>>
>> <!-- Cargo settings -->
>> <cargo.container>tomcat5x</cargo.container>
>> <cargo.container.home>${env.CATALINA_HOME}</
>> cargo.container.home>
>>
>> <cargo.container.url>http://archive.apache.org/dist/tomcat/tomcat-6/v6.0.14/bin/apache-tomcat-6.0.14.zip
>>
>> </cargo.container.url>
>> <cargo.host>localhost</cargo.host>
>> <cargo.port>8081</cargo.port>
>> <cargo.wait>false</cargo.wait>
>>
>> <!-- Database settings -->
>>
>> <
>> dbunit
>> .dataTypeFactoryName
>> >org.dbunit.dataset.datatype.DefaultDataTypeFactory</
>> dbunit.dataTypeFactoryName>
>> <dbunit.operation.type>CLEAN_INSERT</dbunit.operation.type>
>>
>> <hibernate.dialect>org.hibernate.dialect.MySQL5InnoDBDialect</
>> hibernate.dialect>
>> <jdbc.groupId>mysql</jdbc.groupId>
>> <jdbc.artifactId>mysql-connector-java</jdbc.artifactId>
>> <jdbc.version>5.0.5</jdbc.version>
>> <jdbc.driverClassName>com.mysql.jdbc.Driver</
>> jdbc.driverClassName>
>>
>> <jdbc.url><![CDATA[jdbc:mysql://localhost/advert?
>> createDatabaseIfNotExist
>> =true&useUnicode=true&characterEncoding=utf-8]]></jdbc.url>
>> <jdbc.username>root</jdbc.username>
>> <jdbc.password></jdbc.password>
>> </properties>
>>
>>
>> MySQL profile active by default as before?
>>
>> Excuse me for my english:)
>> --
>> View this message in context:
>> http://www.nabble.com/oracle-database-profile%3Aorg.hibernate.exception.JDBCConnectionException-tp19035653s2369p19057712.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]
>
>
>
--
View this message in context:
http://www.nabble.com/oracle-database-profile%3Aorg.hibernate.exception.JDBCConnectionException-tp19035653s2369p19075050.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]
