Allays the same problem when I define all the properties :
# -------------------------------------------------------------------
# T O R Q U E T E S T
# -------------------------------------------------------------------
torque.database.user = ROOT
torque.database.password = ROOT
torque.database.host = ASDEV.arsoe.pl
torque.targetPackage = com.test.torque
torque.database = db2400
torque.database.createUrl = jdbc:as400://ASDEV.arsoe.pl
torque.database.buildUrl = jdbc:as400://ASDEV.arsoe.pl
torque.database.url = jdbc:as400://ASDEV.arsoe.pl
torque.database.driver = com.ibm.as400.access.AS400JDBCDriver
torque.schema.dir = src/main/torque
# Settings to generate torque docs in xdoc format
# and place in xdoc directory for inclusion in
# Maven site:generate goal
torque.doc.format = anakia
torque.doc.dir = xdocs/database
# Added to fix odd Torque plugin problem
# I'd like to eventually remove these
torque.basePrefix = Base
torque.addSaveMethod = true
torque.saveException = Exception
It is for db2 as400 so table have a prefix for the library in the table
name it could be a clue for my problem !
I try to define torque.database.url with the library in the url
jdbc:as400://ASDEV.arsoe.pl/MYLIB but it don't change any thing.
Nicolas
"Brent Atkins" <[EMAIL PROTECTED]>
11/05/2004 15:35
Veuillez r�pondre � "Apache Torque Users List"
Pour : "Apache Torque Users List" <[EMAIL PROTECTED]>
cc :
Objet : RE: maven torque:sql => Connection refused
It looks like you are missing a few properties in your project.properties.
Make sure you have these properties listed...
---
# Database access settings, set according to
# your environment
torque.database.user = [username]
torque.database.password = [password]
torque.database.host = localhost
torque.project = [projectName]
torque.targetPackage = [package]
torque.database = mysql
torque.database.createUrl = jdbc:mysql://localhost:3306/btp
torque.database.buildUrl = jdbc:mysql://localhost:3306/btp
torque.database.url = jdbc:mysql://localhost:3306/btp
torque.database.driver = com.mysql.jdbc.Driver
---
Your error looks like it is because it cannot connect to mySQL (or
whatever database you are using).
If you aren't using mysql, be sure to change your driver and database info
to match your system.
You may also like to add this setting to it...
---
# Settings to generate torque docs in xdoc format
# and place in xdoc directory for inclusion in
# Maven site:generate goal
torque.doc.format = anakia
torque.doc.dir = xdocs/database
---
It'll make Torque output it's documents into the xml format used by Maven
to generate the site docs.
It's pretty useful.
When I was going through this process (on the older version) I also had to
add a couple of
properties to fix it. I don't know if these are still needed...
---
# Added to fix odd Torque plugin problem
# I'd like to eventually remove these
torque.basePrefix = Base
torque.addSaveMethod = true
torque.saveException = Exception
---
There were a couple other fixes I had to make (again, old version), but
this should fix the error
you are having right now. Let me know if afterwards you get another
error, I may be able to help
with that one too.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 11, 2004 5:14 AM
To: [EMAIL PROTECTED]
Subject: maven torque:sql => Connection refused
I just want to create the sql from the project-schema.xml. Maybe I didn't
understand want this goal (torque:sql) do. I don't think that this goal
need to establish a connection with to data base but when I call maven
torque:sql I have an org.apache.torque.engine.EngineException:
java.net.ConnectException: Connection refused: connect.
My project.properties only contains this properties :
torque.schema.dir = src/main/torque
With maven -X torque:sql I have this stack trace :
[DEBUG] Class java.sql.SQLException loaded from parent loader
org.apache.torque.engine.EngineException: java.net.ConnectException:
Connection refused: connect
at
org.apache.torque.engine.database.transform.XmlToAppData.parseFile(XmlToAppData.java:201)
at
org.apache.torque.task.TorqueDataModelTask.initControlContext(TorqueDataModelTask.java:341)
at
org.apache.torque.task.TorqueSQLTask.initControlContext(TorqueSQLTask.java:227)
at
org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java:480)
...
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
at java.net.Socket.connect(Socket.java:426)
at java.net.Socket.connect(Socket.java:376)
at sun.net.NetworkClient.doConnect(NetworkClient.java:139)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:386)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:602)
at sun.net.www.http.HttpClient.<init>(HttpClient.java:303)
at sun.net.www.http.HttpClient.<init>(HttpClient.java:264)
at sun.net.www.http.HttpClient.New(HttpClient.java:336)
at sun.net.www.http.HttpClient.New(HttpClient.java:317)
at sun.net.www.http.HttpClient.New(HttpClient.java:312)
at
sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:481)
at
sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:472)
at
sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:574)
at java.net.URL.openStream(URL.java:960)
at
org.apache.torque.engine.database.transform.DTDResolver.getInputSource(DTDResolver.java:158)
at
org.apache.torque.engine.database.transform.DTDResolver.resolveEntity(DTDResolver.java:144)
at
org.apache.torque.engine.database.transform.XmlToAppData.resolveEntity(XmlToAppData.java:223)
at
org.apache.xerces.util.EntityResolverWrapper.resolveEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityManager.resolveEntity(Unknown
Source)
at
org.apache.xerces.impl.XMLDocumentScannerImpl$DTDDispatcher.dispatch(Unknown
Source)
at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source)
at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown
Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown
Source)
at javax.xml.parsers.SAXParser.parse(Unknown Source)
at
org.apache.torque.engine.database.transform.XmlToAppData.parseFile(XmlToAppData.java:192)
... 46 more
Root cause
org.apache.torque.engine.EngineException: java.net.ConnectException:
Connection refused: connect
at
org.apache.torque.task.TorqueDataModelTask.initControlContext(TorqueDataModelTask.java:364)
at
org.apache.torque.task.TorqueSQLTask.initControlContext(TorqueSQLTask.java:227)
at
org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java:480)
at org.apache.tools.ant.Task.perform(Task.java:341)
at org.apache.commons.jelly.tags.ant.AntTag.doTag(AntTag.java:232)
at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
at
org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
at
org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:233)
at
org.apache.commons.jelly.tags.core.WhenTag.doTag(WhenTag.java:92)
at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
at
org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
at
org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:233)
at
org.apache.commons.jelly.tags.core.ChooseTag.doTag(ChooseTag.java:84)
at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
at
org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
at
org.apache.maven.jelly.tags.werkz.MavenGoalTag.runBodyTag(MavenGoalTag.java:78)
at
org.apache.maven.jelly.tags.werkz.MavenGoalTag$MavenGoalAction.performAction(MavenGoalTag.java:99)
at com.werken.werkz.Goal.fire(Goal.java:639)
at com.werken.werkz.Goal.attain(Goal.java:575)
at com.werken.werkz.WerkzProject.attainGoal(WerkzProject.java:193)
at
org.apache.maven.jelly.tags.werkz.MavenAttainGoalTag.doTag(MavenAttainGoalTag.java:126)
at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
at
org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
at
org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:233)
at
org.apache.commons.jelly.tags.core.OtherwiseTag.doTag(OtherwiseTag.java:87)
at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
at
org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
at
org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:233)
at
org.apache.commons.jelly.tags.core.ChooseTag.doTag(ChooseTag.java:84)
at org.apache.commons.jelly.impl.TagScript.run(TagScript.java:279)
at
org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:135)
at
org.apache.maven.jelly.tags.werkz.MavenGoalTag.runBodyTag(MavenGoalTag.java:78)
at
org.apache.maven.jelly.tags.werkz.MavenGoalTag$MavenGoalAction.performAction(MavenGoalTag.java:99)
at com.werken.werkz.Goal.fire(Goal.java:639)
at com.werken.werkz.Goal.attain(Goal.java:575)
at com.werken.werkz.WerkzProject.attainGoal(WerkzProject.java:193)
at
org.apache.maven.plugin.PluginManager.attainGoals(PluginManager.java:531)
at
org.apache.maven.MavenSession.attainGoals(MavenSession.java:265)
at org.apache.maven.cli.App.doMain(App.java:466)
at org.apache.maven.cli.App.main(App.java:1117)
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:324)
at com.werken.forehead.Forehead.run(Forehead.java:551)
at com.werken.forehead.Forehead.main(Forehead.java:581)
Caused by: org.apache.torque.engine.EngineException:
java.net.ConnectException: Connection refused: connect
at
org.apache.torque.engine.database.transform.XmlToAppData.parseFile(XmlToAppData.java:201)
at
org.apache.torque.task.TorqueDataModelTask.initControlContext(TorqueDataModelTask.java:341)
... 45 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
at java.net.Socket.connect(Socket.java:426)
at java.net.Socket.connect(Socket.java:376)
at sun.net.NetworkClient.doConnect(NetworkClient.java:139)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:386)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:602)
at sun.net.www.http.HttpClient.<init>(HttpClient.java:303)
at sun.net.www.http.HttpClient.<init>(HttpClient.java:264)
at sun.net.www.http.HttpClient.New(HttpClient.java:336)
at sun.net.www.http.HttpClient.New(HttpClient.java:317)
at sun.net.www.http.HttpClient.New(HttpClient.java:312)
at
sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:481)
at
sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:472)
at
sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:574)
at java.net.URL.openStream(URL.java:960)
at
org.apache.torque.engine.database.transform.DTDResolver.getInputSource(DTDResolver.java:158)
at
org.apache.torque.engine.database.transform.DTDResolver.resolveEntity(DTDResolver.java:144)
at
org.apache.torque.engine.database.transform.XmlToAppData.resolveEntity(XmlToAppData.java:223)
at
org.apache.xerces.util.EntityResolverWrapper.resolveEntity(Unknown Source)
at org.apache.xerces.impl.XMLEntityManager.resolveEntity(Unknown
Source)
at
org.apache.xerces.impl.XMLDocumentScannerImpl$DTDDispatcher.dispatch(Unknown
Source)
at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source)
at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown
Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown
Source)
at javax.xml.parsers.SAXParser.parse(Unknown Source)
at
org.apache.torque.engine.database.transform.XmlToAppData.parseFile(XmlToAppData.java:192)
... 46 more
--- Nested Exception ---
org.apache.torque.engine.EngineException: java.net.ConnectException:
Connection refused: connect
at
org.apache.torque.engine.database.transform.XmlToAppData.parseFile(XmlToAppData.java:201)
at
org.apache.torque.task.TorqueDataModelTask.initControlContext(TorqueDataModelTask.java:341)
at
org.apache.torque.task.TorqueSQLTask.initControlContext(TorqueSQLTask.java:227)
...
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
at
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
at java.net.Socket.connect(Socket.java:426)
at java.net.Socket.connect(Socket.java:376)
at sun.net.NetworkClient.doConnect(NetworkClient.java:139)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:386)
...
Total time: 20 seconds
Finished at: Tue May 11 11:09:50 CEST 2004
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
